Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 75166 |
| Missing cells | 82295 |
| Missing cells (%) | 3.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 16.1 MiB |
| Average record size in memory | 224.0 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 15 |
country has a high cardinality: 165 distinct values | High cardinality |
agent has 12310 (16.4%) missing values | Missing |
company has 69560 (92.5%) missing values | Missing |
previous_cancellations is highly skewed (γ1 = 29.14223836) | Skewed |
df_index has unique values | Unique |
lead_time has 5915 (7.9%) zeros | Zeros |
previous_cancellations has 74624 (99.3%) zeros | Zeros |
previous_bookings_not_canceled has 71746 (95.5%) zeros | Zeros |
booking_changes has 59920 (79.7%) zeros | Zeros |
days_in_waiting_list has 73827 (98.2%) zeros | Zeros |
total_of_special_requests has 36762 (48.9%) zeros | Zeros |
Reproduction
| Analysis started | 2023-02-05 02:48:23.103735 |
|---|---|
| Analysis finished | 2023-02-05 02:49:40.814839 |
| Duration | 1 minute and 17.71 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 75166 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66098.29473 |
| Minimum | 0 |
|---|---|
| Maximum | 119389 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13895.25 |
| Q1 | 29905.25 |
| median | 80541.5 |
| Q3 | 100580.75 |
| 95-th percentile | 115629.75 |
| Maximum | 119389 |
| Range | 119389 |
| Interquartile range (IQR) | 70675.5 |
Descriptive statistics
| Standard deviation | 37543.7521 |
|---|---|
| Coefficient of variation (CV) | 0.5679988002 |
| Kurtosis | -1.566288398 |
| Mean | 66098.29473 |
| Median Absolute Deviation (MAD) | 34285.5 |
| Skewness | -0.1500540579 |
| Sum | 4968344422 |
| Variance | 1409533322 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 94295 | 1 | < 0.1% |
| 94312 | 1 | < 0.1% |
| 94311 | 1 | < 0.1% |
| 94310 | 1 | < 0.1% |
| 94309 | 1 | < 0.1% |
| 94307 | 1 | < 0.1% |
| 94306 | 1 | < 0.1% |
| 94305 | 1 | < 0.1% |
| 94304 | 1 | < 0.1% |
| Other values (75156) | 75156 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 11 | 1 | |
| 12 | 1 |
| Value | Count | Frequency (%) |
| 119389 | 1 | |
| 119388 | 1 | |
| 119387 | 1 | |
| 119386 | 1 | |
| 119385 | 1 | |
| 119384 | 1 | |
| 119383 | 1 | |
| 119382 | 1 | |
| 119381 | 1 | |
| 119380 | 1 |
hotel
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| City Hotel | |
|---|---|
| Resort Hotel |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.76997579 |
| Min length | 10 |
Characters and Unicode
| Total characters | 809536 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Resort Hotel |
|---|---|
| 2nd row | Resort Hotel |
| 3rd row | Resort Hotel |
| 4th row | Resort Hotel |
| 5th row | Resort Hotel |
Common Values
| Value | Count | Frequency (%) |
| City Hotel | 46228 | |
| Resort Hotel | 28938 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| hotel | 75166 | |
| city | 46228 | |
| resort | 28938 | 19.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 150332 | |
| o | 104104 | |
| e | 104104 | |
| 75166 | ||
| H | 75166 | |
| l | 75166 | |
| C | 46228 | 5.7% |
| i | 46228 | 5.7% |
| y | 46228 | 5.7% |
| R | 28938 | 3.6% |
| Other values (2) | 57876 | 7.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 584038 | |
| Uppercase Letter | 150332 | 18.6% |
| Space Separator | 75166 | 9.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 150332 | |
| o | 104104 | |
| e | 104104 | |
| l | 75166 | |
| i | 46228 | 7.9% |
| y | 46228 | 7.9% |
| s | 28938 | 5.0% |
| r | 28938 | 5.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 75166 | |
| C | 46228 | |
| R | 28938 | 19.2% |
Space Separator
| Value | Count | Frequency (%) |
| 75166 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 734370 | |
| Common | 75166 | 9.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 150332 | |
| o | 104104 | |
| e | 104104 | |
| H | 75166 | |
| l | 75166 | |
| C | 46228 | 6.3% |
| i | 46228 | 6.3% |
| y | 46228 | 6.3% |
| R | 28938 | 3.9% |
| s | 28938 | 3.9% |
Common
| Value | Count | Frequency (%) |
| 75166 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 809536 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 150332 | |
| o | 104104 | |
| e | 104104 | |
| 75166 | ||
| H | 75166 | |
| l | 75166 | |
| C | 46228 | 5.7% |
| i | 46228 | 5.7% |
| y | 46228 | 5.7% |
| R | 28938 | 3.6% |
| Other values (2) | 57876 | 7.1% |
| Distinct | 422 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79.98468723 |
| Minimum | 0 |
|---|---|
| Maximum | 737 |
| Zeros | 5915 |
| Zeros (%) | 7.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 9 |
| median | 45 |
| Q3 | 124 |
| 95-th percentile | 269 |
| Maximum | 737 |
| Range | 737 |
| Interquartile range (IQR) | 115 |
Descriptive statistics
| Standard deviation | 91.10988782 |
|---|---|
| Coefficient of variation (CV) | 1.139091631 |
| Kurtosis | 2.292428857 |
| Mean | 79.98468723 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 1.526687435 |
| Sum | 6012129 |
| Variance | 8301.011659 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5915 | 7.9% |
| 1 | 3139 | 4.2% |
| 2 | 1856 | 2.5% |
| 3 | 1634 | 2.2% |
| 4 | 1539 | 2.0% |
| 5 | 1359 | 1.8% |
| 6 | 1243 | 1.7% |
| 7 | 1159 | 1.5% |
| 8 | 915 | 1.2% |
| 11 | 834 | 1.1% |
| Other values (412) | 55573 |
| Value | Count | Frequency (%) |
| 0 | 5915 | |
| 1 | 3139 | |
| 2 | 1856 | 2.5% |
| 3 | 1634 | 2.2% |
| 4 | 1539 | 2.0% |
| 5 | 1359 | 1.8% |
| 6 | 1243 | 1.7% |
| 7 | 1159 | 1.5% |
| 8 | 915 | 1.2% |
| 9 | 773 | 1.0% |
| Value | Count | Frequency (%) |
| 737 | 1 | < 0.1% |
| 709 | 1 | < 0.1% |
| 542 | 23 | |
| 532 | 1 | < 0.1% |
| 518 | 22 | |
| 504 | 21 | |
| 479 | 20 | |
| 478 | 2 | < 0.1% |
| 476 | 15 | |
| 468 | 30 |
arrival_date_year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 2016 | |
|---|---|
| 2017 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 300664 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2016 | 36370 | |
| 2017 | 24942 | |
| 2015 | 13854 | 18.4% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2016 | 36370 | |
| 2017 | 24942 | |
| 2015 | 13854 | 18.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 75166 | |
| 0 | 75166 | |
| 1 | 75166 | |
| 6 | 36370 | |
| 7 | 24942 | 8.3% |
| 5 | 13854 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 300664 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 75166 | |
| 0 | 75166 | |
| 1 | 75166 | |
| 6 | 36370 | |
| 7 | 24942 | 8.3% |
| 5 | 13854 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 300664 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 75166 | |
| 0 | 75166 | |
| 1 | 75166 | |
| 6 | 36370 | |
| 7 | 24942 | 8.3% |
| 5 | 13854 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 300664 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 75166 | |
| 0 | 75166 | |
| 1 | 75166 | |
| 6 | 36370 | |
| 7 | 24942 | 8.3% |
| 5 | 13854 | 4.6% |
arrival_date_month
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.526355001 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.153542756 |
|---|---|
| Coefficient of variation (CV) | 0.4832012288 |
| Kurtosis | -1.042706178 |
| Mean | 6.526355001 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.02586837604 |
| Sum | 490560 |
| Variance | 9.944831913 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 8638 | |
| 7 | 7919 | |
| 5 | 7114 | |
| 10 | 6914 | |
| 3 | 6645 | |
| 4 | 6565 | |
| 6 | 6404 | |
| 9 | 6392 | |
| 2 | 5372 | |
| 11 | 4672 | |
| Other values (2) | 8531 |
| Value | Count | Frequency (%) |
| 1 | 4122 | |
| 2 | 5372 | |
| 3 | 6645 | |
| 4 | 6565 | |
| 5 | 7114 | |
| 6 | 6404 | |
| 7 | 7919 | |
| 8 | 8638 | |
| 9 | 6392 | |
| 10 | 6914 |
| Value | Count | Frequency (%) |
| 12 | 4409 | |
| 11 | 4672 | |
| 10 | 6914 | |
| 9 | 6392 | |
| 8 | 8638 | |
| 7 | 7919 | |
| 6 | 6404 | |
| 5 | 7114 | |
| 4 | 6565 | |
| 3 | 6645 |
arrival_date_week_number
Real number (ℝ≥0)
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.08014262 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 28 |
| Q3 | 38 |
| 95-th percentile | 49 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.90247758 |
|---|---|
| Coefficient of variation (CV) | 0.5133827311 |
| Kurtosis | -1.034346993 |
| Mean | 27.08014262 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.008567424333 |
| Sum | 2035506 |
| Variance | 193.2788827 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 2075 | 2.8% |
| 34 | 1996 | 2.7% |
| 32 | 1879 | 2.5% |
| 30 | 1844 | 2.5% |
| 28 | 1804 | 2.4% |
| 21 | 1794 | 2.4% |
| 29 | 1747 | 2.3% |
| 31 | 1746 | 2.3% |
| 42 | 1681 | 2.2% |
| 27 | 1679 | 2.2% |
| Other values (43) | 56921 |
| Value | Count | Frequency (%) |
| 1 | 694 | |
| 2 | 823 | |
| 3 | 984 | |
| 4 | 981 | |
| 5 | 962 | |
| 6 | 1123 | |
| 7 | 1425 | |
| 8 | 1423 | |
| 9 | 1393 | |
| 10 | 1412 |
| Value | Count | Frequency (%) |
| 53 | 1172 | |
| 52 | 841 | |
| 51 | 687 | |
| 50 | 908 | |
| 49 | 1117 | |
| 48 | 1129 | |
| 47 | 1309 | |
| 46 | 985 | |
| 45 | 1180 | |
| 44 | 1527 |
arrival_date_day_of_month
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.83952851 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.776422332 |
|---|---|
| Coefficient of variation (CV) | 0.5540835591 |
| Kurtosis | -1.186816098 |
| Mean | 15.83952851 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.007459004258 |
| Sum | 1190594 |
| Variance | 77.02558894 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 25 | 2680 | 3.6% |
| 2 | 2670 | 3.6% |
| 18 | 2642 | 3.5% |
| 5 | 2638 | 3.5% |
| 19 | 2583 | 3.4% |
| 17 | 2569 | 3.4% |
| 6 | 2556 | 3.4% |
| 20 | 2549 | 3.4% |
| 9 | 2546 | 3.4% |
| 12 | 2541 | 3.4% |
| Other values (21) | 49192 |
| Value | Count | Frequency (%) |
| 1 | 2182 | |
| 2 | 2670 | |
| 3 | 2310 | |
| 4 | 2412 | |
| 5 | 2638 | |
| 6 | 2556 | |
| 7 | 2224 | |
| 8 | 2274 | |
| 9 | 2546 | |
| 10 | 2389 |
| Value | Count | Frequency (%) |
| 31 | 1448 | |
| 30 | 2390 | |
| 29 | 2318 | |
| 28 | 2435 | |
| 27 | 2387 | |
| 26 | 2521 | |
| 25 | 2680 | |
| 24 | 2494 | |
| 23 | 2440 | |
| 22 | 2255 |
adults
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 2 | |
|---|---|
| 1 | |
| 3 | 4051 |
| 0 | 294 |
| 4 | 46 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75166 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75166 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 75166 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75166 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
children
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 0.0 | |
|---|---|
| 1.0 | 3294 |
| 2.0 | 2111 |
| 3.0 | 59 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 225498 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 69702 | |
| 1.0 | 3294 | 4.4% |
| 2.0 | 2111 | 2.8% |
| 3.0 | 59 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0.0 | 69702 | |
| 1.0 | 3294 | 4.4% |
| 2.0 | 2111 | 2.8% |
| 3.0 | 59 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 144868 | |
| . | 75166 | |
| 1 | 3294 | 1.5% |
| 2 | 2111 | 0.9% |
| 3 | 59 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 150332 | |
| Other Punctuation | 75166 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 144868 | |
| 1 | 3294 | 2.2% |
| 2 | 2111 | 1.4% |
| 3 | 59 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 75166 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 225498 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 144868 | |
| . | 75166 | |
| 1 | 3294 | 1.5% |
| 2 | 2111 | 0.9% |
| 3 | 59 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 225498 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 144868 | |
| . | 75166 | |
| 1 | 3294 | 1.5% |
| 2 | 2111 | 0.9% |
| 3 | 59 | < 0.1% |
babies
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 0 | |
|---|---|
| 1 | 735 |
| 2 | 13 |
| 10 | 1 |
| 9 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.000013304 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75167 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 74416 | |
| 1 | 735 | 1.0% |
| 2 | 13 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 74416 | |
| 1 | 735 | 1.0% |
| 2 | 13 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 74417 | |
| 1 | 736 | 1.0% |
| 2 | 13 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75167 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 74417 | |
| 1 | 736 | 1.0% |
| 2 | 13 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 75167 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 74417 | |
| 1 | 736 | 1.0% |
| 2 | 13 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75167 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 74417 | |
| 1 | 736 | 1.0% |
| 2 | 13 | < 0.1% |
| 9 | 1 | < 0.1% |
meal
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| BB | |
|---|---|
| HB | |
| SC | |
| Undefined | 883 |
| FB | 320 |
Length
| Max length | 9 |
|---|---|
| Median length | 2 |
| Mean length | 2.082231328 |
| Min length | 2 |
Characters and Unicode
| Total characters | 156513 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | BB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
Common Values
| Value | Count | Frequency (%) |
| BB | 57800 | |
| HB | 9479 | 12.6% |
| SC | 6684 | 8.9% |
| Undefined | 883 | 1.2% |
| FB | 320 | 0.4% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| bb | 57800 | |
| hb | 9479 | 12.6% |
| sc | 6684 | 8.9% |
| undefined | 883 | 1.2% |
| fb | 320 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 125399 | |
| H | 9479 | 6.1% |
| S | 6684 | 4.3% |
| C | 6684 | 4.3% |
| n | 1766 | 1.1% |
| d | 1766 | 1.1% |
| e | 1766 | 1.1% |
| U | 883 | 0.6% |
| f | 883 | 0.6% |
| i | 883 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 149449 | |
| Lowercase Letter | 7064 | 4.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 125399 | |
| H | 9479 | 6.3% |
| S | 6684 | 4.5% |
| C | 6684 | 4.5% |
| U | 883 | 0.6% |
| F | 320 | 0.2% |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 1766 | |
| d | 1766 | |
| e | 1766 | |
| f | 883 | |
| i | 883 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 156513 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 125399 | |
| H | 9479 | 6.1% |
| S | 6684 | 4.3% |
| C | 6684 | 4.3% |
| n | 1766 | 1.1% |
| d | 1766 | 1.1% |
| e | 1766 | 1.1% |
| U | 883 | 0.6% |
| f | 883 | 0.6% |
| i | 883 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 156513 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| B | 125399 | |
| H | 9479 | 6.1% |
| S | 6684 | 4.3% |
| C | 6684 | 4.3% |
| n | 1766 | 1.1% |
| d | 1766 | 1.1% |
| e | 1766 | 1.1% |
| U | 883 | 0.6% |
| f | 883 | 0.6% |
| i | 883 | 0.6% |
| Distinct | 165 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 421 |
| Missing (%) | 0.6% |
| Memory size | 587.4 KiB |
| PRT | |
|---|---|
| GBR | |
| FRA | |
| ESP | |
| DEU | |
| Other values (160) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.986286708 |
| Min length | 2 |
Characters and Unicode
| Total characters | 223210 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 31 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PRT |
|---|---|
| 2nd row | PRT |
| 3rd row | GBR |
| 4th row | GBR |
| 5th row | GBR |
Common Values
| Value | Count | Frequency (%) |
| PRT | 21071 | |
| GBR | 9676 | |
| FRA | 8481 | |
| ESP | 6391 | 8.5% |
| DEU | 6069 | 8.1% |
| IRL | 2543 | 3.4% |
| ITA | 2433 | 3.2% |
| BEL | 1868 | 2.5% |
| NLD | 1717 | 2.3% |
| USA | 1596 | 2.1% |
| Other values (155) | 12900 |
Length
| Value | Count | Frequency (%) |
| prt | 21071 | |
| gbr | 9676 | |
| fra | 8481 | |
| esp | 6391 | 8.6% |
| deu | 6069 | 8.1% |
| irl | 2543 | 3.4% |
| ita | 2433 | 3.3% |
| bel | 1868 | 2.5% |
| nld | 1717 | 2.3% |
| usa | 1596 | 2.1% |
| Other values (155) | 12900 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 45992 | |
| P | 28483 | |
| T | 24966 | |
| E | 16818 | 7.5% |
| A | 16083 | 7.2% |
| B | 13222 | 5.9% |
| U | 10476 | 4.7% |
| S | 10385 | 4.7% |
| G | 10248 | 4.6% |
| F | 8917 | 4.0% |
| Other values (16) | 37620 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 223210 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 45992 | |
| P | 28483 | |
| T | 24966 | |
| E | 16818 | 7.5% |
| A | 16083 | 7.2% |
| B | 13222 | 5.9% |
| U | 10476 | 4.7% |
| S | 10385 | 4.7% |
| G | 10248 | 4.6% |
| F | 8917 | 4.0% |
| Other values (16) | 37620 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 223210 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 45992 | |
| P | 28483 | |
| T | 24966 | |
| E | 16818 | 7.5% |
| A | 16083 | 7.2% |
| B | 13222 | 5.9% |
| U | 10476 | 4.7% |
| S | 10385 | 4.7% |
| G | 10248 | 4.6% |
| F | 8917 | 4.0% |
| Other values (16) | 37620 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 223210 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 45992 | |
| P | 28483 | |
| T | 24966 | |
| E | 16818 | 7.5% |
| A | 16083 | 7.2% |
| B | 13222 | 5.9% |
| U | 10476 | 4.7% |
| S | 10385 | 4.7% |
| G | 10248 | 4.6% |
| F | 8917 | 4.0% |
| Other values (16) | 37620 |
market_segment
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Direct | |
| Groups | |
| Corporate | |
| Other values (2) | 831 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.144653168 |
| Min length | 6 |
Characters and Unicode
| Total characters | 687367 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Corporate |
| 5th row | Online TA |
Common Values
| Value | Count | Frequency (%) |
| Online TA | 35738 | |
| Offline TA/TO | 15908 | |
| Direct | 10672 | 14.2% |
| Groups | 7714 | 10.3% |
| Corporate | 4303 | 5.7% |
| Complementary | 646 | 0.9% |
| Aviation | 185 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| online | 35738 | |
| ta | 35738 | |
| offline | 15908 | |
| ta/to | 15908 | |
| direct | 10672 | 8.4% |
| groups | 7714 | 6.1% |
| corporate | 4303 | 3.4% |
| complementary | 646 | 0.5% |
| aviation | 185 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 88215 | |
| e | 67913 | |
| O | 67554 | |
| T | 67554 | |
| i | 62688 | |
| l | 52292 | |
| A | 51831 | |
| 51646 | ||
| f | 31816 | 4.6% |
| r | 27638 | 4.0% |
| Other values (14) | 118220 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 409539 | |
| Uppercase Letter | 210274 | |
| Space Separator | 51646 | 7.5% |
| Other Punctuation | 15908 | 2.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 88215 | |
| e | 67913 | |
| i | 62688 | |
| l | 52292 | |
| f | 31816 | 7.8% |
| r | 27638 | 6.7% |
| o | 17151 | 4.2% |
| t | 15806 | 3.9% |
| p | 12663 | 3.1% |
| c | 10672 | 2.6% |
| Other values (6) | 22685 | 5.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 67554 | |
| T | 67554 | |
| A | 51831 | |
| D | 10672 | 5.1% |
| G | 7714 | 3.7% |
| C | 4949 | 2.4% |
Space Separator
| Value | Count | Frequency (%) |
| 51646 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 15908 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 619813 | |
| Common | 67554 | 9.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 88215 | |
| e | 67913 | |
| O | 67554 | |
| T | 67554 | |
| i | 62688 | |
| l | 52292 | |
| A | 51831 | |
| f | 31816 | 5.1% |
| r | 27638 | 4.5% |
| o | 17151 | 2.8% |
| Other values (12) | 85161 |
Common
| Value | Count | Frequency (%) |
| 51646 | ||
| / | 15908 | 23.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 687367 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 88215 | |
| e | 67913 | |
| O | 67554 | |
| T | 67554 | |
| i | 62688 | |
| l | 52292 | |
| A | 51831 | |
| 51646 | ||
| f | 31816 | 4.6% |
| r | 27638 | 4.0% |
| Other values (14) | 118220 |
distribution_channel
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| TA/TO | |
|---|---|
| Direct | |
| Corporate | 5203 |
| GDS | 156 |
| Undefined | 1 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.433600298 |
| Min length | 3 |
Characters and Unicode
| Total characters | 408422 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Corporate |
| 5th row | TA/TO |
Common Values
| Value | Count | Frequency (%) |
| TA/TO | 57718 | |
| Direct | 12088 | 16.1% |
| Corporate | 5203 | 6.9% |
| GDS | 156 | 0.2% |
| Undefined | 1 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| ta/to | 57718 | |
| direct | 12088 | 16.1% |
| corporate | 5203 | 6.9% |
| gds | 156 | 0.2% |
| undefined | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 115436 | |
| / | 57718 | |
| O | 57718 | |
| A | 57718 | |
| r | 22494 | 5.5% |
| e | 17293 | 4.2% |
| t | 17291 | 4.2% |
| D | 12244 | 3.0% |
| i | 12089 | 3.0% |
| c | 12088 | 3.0% |
| Other values (10) | 26333 | 6.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 248632 | |
| Lowercase Letter | 102072 | |
| Other Punctuation | 57718 | 14.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 22494 | |
| e | 17293 | |
| t | 17291 | |
| i | 12089 | |
| c | 12088 | |
| o | 10406 | |
| a | 5203 | 5.1% |
| p | 5203 | 5.1% |
| n | 2 | < 0.1% |
| d | 2 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 115436 | |
| O | 57718 | |
| A | 57718 | |
| D | 12244 | 4.9% |
| C | 5203 | 2.1% |
| G | 156 | 0.1% |
| S | 156 | 0.1% |
| U | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 57718 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 350704 | |
| Common | 57718 | 14.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 115436 | |
| O | 57718 | |
| A | 57718 | |
| r | 22494 | 6.4% |
| e | 17293 | 4.9% |
| t | 17291 | 4.9% |
| D | 12244 | 3.5% |
| i | 12089 | 3.4% |
| c | 12088 | 3.4% |
| o | 10406 | 3.0% |
| Other values (9) | 15927 | 4.5% |
Common
| Value | Count | Frequency (%) |
| / | 57718 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 408422 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 115436 | |
| / | 57718 | |
| O | 57718 | |
| A | 57718 | |
| r | 22494 | 5.5% |
| e | 17293 | 4.2% |
| t | 17291 | 4.2% |
| D | 12244 | 3.0% |
| i | 12089 | 3.0% |
| c | 12088 | 3.0% |
| Other values (10) | 26333 | 6.4% |
is_repeated_guest
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 0 | |
|---|---|
| 1 | 3258 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75166 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75166 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 75166 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75166 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.01579171434 |
| Minimum | 0 |
|---|---|
| Maximum | 13 |
| Zeros | 74624 |
| Zeros (%) | 99.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2724214875 |
|---|---|
| Coefficient of variation (CV) | 17.25091283 |
| Kurtosis | 1043.553303 |
| Mean | 0.01579171434 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 29.14223836 |
| Sum | 1187 |
| Variance | 0.07421346684 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 74624 | |
| 1 | 337 | 0.4% |
| 2 | 78 | 0.1% |
| 3 | 45 | 0.1% |
| 11 | 25 | < 0.1% |
| 4 | 24 | < 0.1% |
| 5 | 17 | < 0.1% |
| 6 | 15 | < 0.1% |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 74624 | |
| 1 | 337 | 0.4% |
| 2 | 78 | 0.1% |
| 3 | 45 | 0.1% |
| 4 | 24 | < 0.1% |
| 5 | 17 | < 0.1% |
| 6 | 15 | < 0.1% |
| 11 | 25 | < 0.1% |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13 | 1 | < 0.1% |
| 11 | 25 | < 0.1% |
| 6 | 15 | < 0.1% |
| 5 | 17 | < 0.1% |
| 4 | 24 | < 0.1% |
| 3 | 45 | 0.1% |
| 2 | 78 | 0.1% |
| 1 | 337 | 0.4% |
| 0 | 74624 |
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.20297741 |
| Minimum | 0 |
|---|---|
| Maximum | 72 |
| Zeros | 71746 |
| Zeros (%) | 95.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.81071327 |
|---|---|
| Coefficient of variation (CV) | 8.920762514 |
| Kurtosis | 534.2063652 |
| Mean | 0.20297741 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.60351104 |
| Sum | 15257 |
| Variance | 3.278682547 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 71746 | |
| 1 | 1463 | 1.9% |
| 2 | 548 | 0.7% |
| 3 | 316 | 0.4% |
| 4 | 217 | 0.3% |
| 5 | 170 | 0.2% |
| 6 | 112 | 0.1% |
| 7 | 83 | 0.1% |
| 8 | 67 | 0.1% |
| 9 | 60 | 0.1% |
| Other values (63) | 384 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 71746 | |
| 1 | 1463 | 1.9% |
| 2 | 548 | 0.7% |
| 3 | 316 | 0.4% |
| 4 | 217 | 0.3% |
| 5 | 170 | 0.2% |
| 6 | 112 | 0.1% |
| 7 | 83 | 0.1% |
| 8 | 67 | 0.1% |
| 9 | 60 | 0.1% |
| Value | Count | Frequency (%) |
| 72 | 1 | |
| 71 | 1 | |
| 70 | 1 | |
| 69 | 1 | |
| 68 | 1 | |
| 67 | 1 | |
| 66 | 1 | |
| 65 | 1 | |
| 64 | 1 | |
| 63 | 1 |
reserved_room_type
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| A | |
|---|---|
| D | |
| E | 4621 |
| F | 2017 |
| G | 1331 |
| Other values (4) | 1734 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75166 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 52364 | |
| D | 13099 | 17.4% |
| E | 4621 | 6.1% |
| F | 2017 | 2.7% |
| G | 1331 | 1.8% |
| B | 750 | 1.0% |
| C | 624 | 0.8% |
| H | 356 | 0.5% |
| L | 4 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| a | 52364 | |
| d | 13099 | 17.4% |
| e | 4621 | 6.1% |
| f | 2017 | 2.7% |
| g | 1331 | 1.8% |
| b | 750 | 1.0% |
| c | 624 | 0.8% |
| h | 356 | 0.5% |
| l | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 52364 | |
| D | 13099 | 17.4% |
| E | 4621 | 6.1% |
| F | 2017 | 2.7% |
| G | 1331 | 1.8% |
| B | 750 | 1.0% |
| C | 624 | 0.8% |
| H | 356 | 0.5% |
| L | 4 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 75166 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 52364 | |
| D | 13099 | 17.4% |
| E | 4621 | 6.1% |
| F | 2017 | 2.7% |
| G | 1331 | 1.8% |
| B | 750 | 1.0% |
| C | 624 | 0.8% |
| H | 356 | 0.5% |
| L | 4 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 75166 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 52364 | |
| D | 13099 | 17.4% |
| E | 4621 | 6.1% |
| F | 2017 | 2.7% |
| G | 1331 | 1.8% |
| B | 750 | 1.0% |
| C | 624 | 0.8% |
| H | 356 | 0.5% |
| L | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75166 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 52364 | |
| D | 13099 | 17.4% |
| E | 4621 | 6.1% |
| F | 2017 | 2.7% |
| G | 1331 | 1.8% |
| B | 750 | 1.0% |
| C | 624 | 0.8% |
| H | 356 | 0.5% |
| L | 4 | < 0.1% |
assigned_room_type
Categorical
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| A | |
|---|---|
| D | |
| E | |
| F | 2824 |
| C | 1929 |
| Other values (5) |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75166 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | C |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 41105 | |
| D | 18960 | |
| E | 5838 | 7.8% |
| F | 2824 | 3.8% |
| C | 1929 | 2.6% |
| G | 1773 | 2.4% |
| B | 1651 | 2.2% |
| H | 461 | 0.6% |
| I | 358 | 0.5% |
| K | 267 | 0.4% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| a | 41105 | |
| d | 18960 | |
| e | 5838 | 7.8% |
| f | 2824 | 3.8% |
| c | 1929 | 2.6% |
| g | 1773 | 2.4% |
| b | 1651 | 2.2% |
| h | 461 | 0.6% |
| i | 358 | 0.5% |
| k | 267 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 41105 | |
| D | 18960 | |
| E | 5838 | 7.8% |
| F | 2824 | 3.8% |
| C | 1929 | 2.6% |
| G | 1773 | 2.4% |
| B | 1651 | 2.2% |
| H | 461 | 0.6% |
| I | 358 | 0.5% |
| K | 267 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 75166 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 41105 | |
| D | 18960 | |
| E | 5838 | 7.8% |
| F | 2824 | 3.8% |
| C | 1929 | 2.6% |
| G | 1773 | 2.4% |
| B | 1651 | 2.2% |
| H | 461 | 0.6% |
| I | 358 | 0.5% |
| K | 267 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 75166 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 41105 | |
| D | 18960 | |
| E | 5838 | 7.8% |
| F | 2824 | 3.8% |
| C | 1929 | 2.6% |
| G | 1773 | 2.4% |
| B | 1651 | 2.2% |
| H | 461 | 0.6% |
| I | 358 | 0.5% |
| K | 267 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75166 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 41105 | |
| D | 18960 | |
| E | 5838 | 7.8% |
| F | 2824 | 3.8% |
| C | 1929 | 2.6% |
| G | 1773 | 2.4% |
| B | 1651 | 2.2% |
| H | 461 | 0.6% |
| I | 358 | 0.5% |
| K | 267 | 0.4% |
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2933663287 |
| Minimum | 0 |
|---|---|
| Maximum | 21 |
| Zeros | 59920 |
| Zeros (%) | 79.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7362788719 |
|---|---|
| Coefficient of variation (CV) | 2.5097593 |
| Kurtosis | 66.61474151 |
| Mean | 0.2933663287 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.397378632 |
| Sum | 22050 |
| Variance | 0.5421065772 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 59920 | |
| 1 | 10893 | 14.5% |
| 2 | 3039 | 4.0% |
| 3 | 783 | 1.0% |
| 4 | 309 | 0.4% |
| 5 | 98 | 0.1% |
| 6 | 45 | 0.1% |
| 7 | 28 | < 0.1% |
| 8 | 13 | < 0.1% |
| 9 | 7 | < 0.1% |
| Other values (11) | 27 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 59920 | |
| 1 | 10893 | 14.5% |
| 2 | 3039 | 4.0% |
| 3 | 783 | 1.0% |
| 4 | 309 | 0.4% |
| 5 | 98 | 0.1% |
| 6 | 45 | 0.1% |
| 7 | 28 | < 0.1% |
| 8 | 13 | < 0.1% |
| 9 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 1 | < 0.1% |
| 15 | 3 | |
| 14 | 4 | |
| 13 | 5 | |
| 12 | 2 | < 0.1% |
| 11 | 2 | < 0.1% |
deposit_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| No Deposit | |
|---|---|
| Refundable | 126 |
| Non Refund | 93 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 751660 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
Common Values
| Value | Count | Frequency (%) |
| No Deposit | 74947 | |
| Refundable | 126 | 0.2% |
| Non Refund | 93 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| no | 74947 | |
| deposit | 74947 | |
| refundable | 126 | 0.1% |
| non | 93 | 0.1% |
| refund | 93 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 149987 | |
| e | 75292 | |
| N | 75040 | |
| 75040 | ||
| s | 74947 | |
| i | 74947 | |
| t | 74947 | |
| p | 74947 | |
| D | 74947 | |
| n | 312 | < 0.1% |
| Other values (7) | 1254 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 526414 | |
| Uppercase Letter | 150206 | 20.0% |
| Space Separator | 75040 | 10.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 149987 | |
| e | 75292 | |
| s | 74947 | |
| i | 74947 | |
| t | 74947 | |
| p | 74947 | |
| n | 312 | 0.1% |
| f | 219 | < 0.1% |
| u | 219 | < 0.1% |
| d | 219 | < 0.1% |
| Other values (3) | 378 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 75040 | |
| D | 74947 | |
| R | 219 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 75040 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 676620 | |
| Common | 75040 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 149987 | |
| e | 75292 | |
| N | 75040 | |
| s | 74947 | |
| i | 74947 | |
| t | 74947 | |
| p | 74947 | |
| D | 74947 | |
| n | 312 | < 0.1% |
| R | 219 | < 0.1% |
| Other values (6) | 1035 | 0.2% |
Common
| Value | Count | Frequency (%) |
| 75040 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 751660 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 149987 | |
| e | 75292 | |
| N | 75040 | |
| 75040 | ||
| s | 74947 | |
| i | 74947 | |
| t | 74947 | |
| p | 74947 | |
| D | 74947 | |
| n | 312 | < 0.1% |
| Other values (7) | 1254 | 0.2% |
| Distinct | 314 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 12310 |
| Missing (%) | 16.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.0557942 |
| Minimum | 1 |
|---|---|
| Maximum | 535 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 9 |
| median | 14 |
| Q3 | 240 |
| 95-th percentile | 273 |
| Maximum | 535 |
| Range | 534 |
| Interquartile range (IQR) | 231 |
Descriptive statistics
| Standard deviation | 113.947162 |
|---|---|
| Coefficient of variation (CV) | 1.211484768 |
| Kurtosis | -0.2374568407 |
| Mean | 94.0557942 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.9779323318 |
| Sum | 5911971 |
| Variance | 12983.95573 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 18697 | |
| 240 | 8438 | |
| 7 | 3065 | 4.1% |
| 14 | 2988 | 4.0% |
| 250 | 2357 | 3.1% |
| 6 | 2265 | 3.0% |
| 1 | 1911 | 2.5% |
| 28 | 1556 | 2.1% |
| 241 | 1485 | 2.0% |
| 8 | 1087 | 1.4% |
| Other values (304) | 19007 | |
| (Missing) | 12310 |
| Value | Count | Frequency (%) |
| 1 | 1911 | 2.5% |
| 2 | 128 | 0.2% |
| 3 | 565 | 0.8% |
| 4 | 16 | < 0.1% |
| 5 | 181 | 0.2% |
| 6 | 2265 | 3.0% |
| 7 | 3065 | 4.1% |
| 8 | 1087 | 1.4% |
| 9 | 18697 | |
| 10 | 196 | 0.3% |
| Value | Count | Frequency (%) |
| 535 | 3 | < 0.1% |
| 531 | 22 | |
| 527 | 35 | |
| 526 | 9 | < 0.1% |
| 510 | 2 | < 0.1% |
| 509 | 8 | < 0.1% |
| 508 | 6 | < 0.1% |
| 502 | 24 | |
| 497 | 1 | < 0.1% |
| 495 | 7 | < 0.1% |
| Distinct | 331 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 69560 |
| Missing (%) | 92.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 190.5192651 |
| Minimum | 6 |
|---|---|
| Maximum | 541 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 51 |
| median | 183 |
| Q3 | 270 |
| 95-th percentile | 437 |
| Maximum | 541 |
| Range | 535 |
| Interquartile range (IQR) | 219 |
Descriptive statistics
| Standard deviation | 132.3492861 |
|---|---|
| Coefficient of variation (CV) | 0.6946766566 |
| Kurtosis | -0.4896916298 |
| Mean | 190.5192651 |
| Median Absolute Deviation (MAD) | 107 |
| Skewness | 0.5873683742 |
| Sum | 1068051 |
| Variance | 17516.33353 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40 | 850 | 1.1% |
| 223 | 665 | 0.9% |
| 45 | 222 | 0.3% |
| 153 | 167 | 0.2% |
| 219 | 132 | 0.2% |
| 174 | 128 | 0.2% |
| 154 | 128 | 0.2% |
| 281 | 121 | 0.2% |
| 233 | 103 | 0.1% |
| 405 | 101 | 0.1% |
| Other values (321) | 2989 | 4.0% |
| (Missing) | 69560 |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 34 | |
| 10 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 12 | 14 | < 0.1% |
| 14 | 8 | < 0.1% |
| 16 | 5 | < 0.1% |
| 18 | 1 | < 0.1% |
| 20 | 39 |
| Value | Count | Frequency (%) |
| 541 | 1 | < 0.1% |
| 539 | 2 | < 0.1% |
| 534 | 2 | < 0.1% |
| 530 | 4 | < 0.1% |
| 528 | 2 | < 0.1% |
| 525 | 15 | |
| 523 | 19 | |
| 521 | 6 | < 0.1% |
| 520 | 1 | < 0.1% |
| 518 | 2 | < 0.1% |
| Distinct | 98 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.589867759 |
| Minimum | 0 |
|---|---|
| Maximum | 379 |
| Zeros | 73827 |
| Zeros (%) | 98.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 379 |
| Range | 379 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 14.78487546 |
|---|---|
| Coefficient of variation (CV) | 9.299437246 |
| Kurtosis | 192.7357548 |
| Mean | 1.589867759 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.59756589 |
| Sum | 119504 |
| Variance | 218.5925423 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 73827 | |
| 58 | 164 | 0.2% |
| 87 | 76 | 0.1% |
| 122 | 53 | 0.1% |
| 63 | 51 | 0.1% |
| 38 | 47 | 0.1% |
| 176 | 39 | 0.1% |
| 77 | 37 | < 0.1% |
| 223 | 36 | < 0.1% |
| 65 | 35 | < 0.1% |
| Other values (88) | 801 | 1.1% |
| Value | Count | Frequency (%) |
| 0 | 73827 | |
| 1 | 9 | < 0.1% |
| 2 | 4 | < 0.1% |
| 4 | 17 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 16 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 379 | 6 | < 0.1% |
| 330 | 14 | < 0.1% |
| 259 | 10 | < 0.1% |
| 236 | 29 | |
| 224 | 4 | < 0.1% |
| 223 | 36 | |
| 215 | 8 | < 0.1% |
| 207 | 10 | < 0.1% |
| 187 | 22 | |
| 185 | 2 | < 0.1% |
customer_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 2814 |
| Group | 518 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.43048719 |
| Min length | 5 |
Characters and Unicode
| Total characters | 784018 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient |
| 3rd row | Transient |
| 4th row | Transient |
| 5th row | Transient |
Common Values
| Value | Count | Frequency (%) |
| Transient | 53099 | |
| Transient-Party | 18735 | 24.9% |
| Contract | 2814 | 3.7% |
| Group | 518 | 0.7% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| transient | 53099 | |
| transient-party | 18735 | 24.9% |
| contract | 2814 | 3.7% |
| group | 518 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 146482 | |
| t | 96197 | |
| r | 93901 | |
| a | 93383 | |
| T | 71834 | |
| s | 71834 | |
| i | 71834 | |
| e | 71834 | |
| y | 18735 | 2.4% |
| - | 18735 | 2.4% |
| Other values (7) | 29249 | 3.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 671382 | |
| Uppercase Letter | 93901 | 12.0% |
| Dash Punctuation | 18735 | 2.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 146482 | |
| t | 96197 | |
| r | 93901 | |
| a | 93383 | |
| s | 71834 | |
| i | 71834 | |
| e | 71834 | |
| y | 18735 | 2.8% |
| o | 3332 | 0.5% |
| c | 2814 | 0.4% |
| Other values (2) | 1036 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 71834 | |
| P | 18735 | 20.0% |
| C | 2814 | 3.0% |
| G | 518 | 0.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 18735 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 765283 | |
| Common | 18735 | 2.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 146482 | |
| t | 96197 | |
| r | 93901 | |
| a | 93383 | |
| T | 71834 | |
| s | 71834 | |
| i | 71834 | |
| e | 71834 | |
| y | 18735 | 2.4% |
| P | 18735 | 2.4% |
| Other values (6) | 10514 | 1.4% |
Common
| Value | Count | Frequency (%) |
| - | 18735 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 784018 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 146482 | |
| t | 96197 | |
| r | 93901 | |
| a | 93383 | |
| T | 71834 | |
| s | 71834 | |
| i | 71834 | |
| e | 71834 | |
| y | 18735 | 2.4% |
| - | 18735 | 2.4% |
| Other values (7) | 29249 | 3.7% |
required_car_parking_spaces
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 0 | |
|---|---|
| 1 | |
| 2 | 28 |
| 3 | 3 |
| 8 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75166 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75166 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 75166 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75166 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7140595482 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 36762 |
| Zeros (%) | 48.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.833886853 |
|---|---|
| Coefficient of variation (CV) | 1.167811361 |
| Kurtosis | 0.8969141785 |
| Mean | 0.7140595482 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.077975244 |
| Sum | 53673 |
| Variance | 0.6953672836 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 36762 | |
| 1 | 25908 | |
| 2 | 10103 | 13.4% |
| 3 | 2051 | 2.7% |
| 4 | 304 | 0.4% |
| 5 | 38 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 36762 | |
| 1 | 25908 | |
| 2 | 10103 | 13.4% |
| 3 | 2051 | 2.7% |
| 4 | 304 | 0.4% |
| 5 | 38 | 0.1% |
| Value | Count | Frequency (%) |
| 5 | 38 | 0.1% |
| 4 | 304 | 0.4% |
| 3 | 2051 | 2.7% |
| 2 | 10103 | 13.4% |
| 1 | 25908 | |
| 0 | 36762 |
stays_total
Real number (ℝ≥0)
| Distinct | 43 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.393023441 |
| Minimum | 0 |
|---|---|
| Maximum | 69 |
| Zeros | 680 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 7 |
| Maximum | 69 |
| Range | 69 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.577670726 |
|---|---|
| Coefficient of variation (CV) | 0.7596972936 |
| Kurtosis | 30.80112497 |
| Mean | 3.393023441 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.19584567 |
| Sum | 255040 |
| Variance | 6.64438637 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 15749 | |
| 3 | 15725 | |
| 2 | 15480 | |
| 4 | 11025 | |
| 7 | 5686 | 7.6% |
| 5 | 5121 | 6.8% |
| 6 | 2322 | 3.1% |
| 10 | 783 | 1.0% |
| 8 | 720 | 1.0% |
| 0 | 680 | 0.9% |
| Other values (33) | 1875 | 2.5% |
| Value | Count | Frequency (%) |
| 0 | 680 | 0.9% |
| 1 | 15749 | |
| 2 | 15480 | |
| 3 | 15725 | |
| 4 | 11025 | |
| 5 | 5121 | 6.8% |
| 6 | 2322 | 3.1% |
| 7 | 5686 | 7.6% |
| 8 | 720 | 1.0% |
| 9 | 528 | 0.7% |
| Value | Count | Frequency (%) |
| 69 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| 57 | 1 | < 0.1% |
| 56 | 1 | < 0.1% |
| 49 | 1 | < 0.1% |
| 48 | 1 | < 0.1% |
| 46 | 1 | < 0.1% |
| 45 | 1 | < 0.1% |
| 43 | 1 | < 0.1% |
| 42 | 3 |
First rows
| df_index | hotel | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | required_car_parking_spaces | total_of_special_requests | stays_total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | Resort Hotel | 342 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 3.0 | No Deposit | nan | nan | 0 | Transient | 0 | 0 | 0 |
| 1 | 1 | Resort Hotel | 737 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 4.0 | No Deposit | nan | nan | 0 | Transient | 0 | 0 | 0 |
| 2 | 2 | Resort Hotel | 7 | 2015 | 7 | 27 | 1 | 1 | 0.0 | 0 | BB | GBR | Direct | Direct | 0 | 0 | 0 | A | C | 0.0 | No Deposit | nan | nan | 0 | Transient | 0 | 0 | 1 |
| 3 | 3 | Resort Hotel | 13 | 2015 | 7 | 27 | 1 | 1 | 0.0 | 0 | BB | GBR | Corporate | Corporate | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 304.0 | nan | 0 | Transient | 0 | 0 | 1 |
| 4 | 4 | Resort Hotel | 14 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 240.0 | nan | 0 | Transient | 0 | 1 | 2 |
| 5 | 5 | Resort Hotel | 14 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 240.0 | nan | 0 | Transient | 0 | 1 | 2 |
| 6 | 6 | Resort Hotel | 0 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0.0 | No Deposit | nan | nan | 0 | Transient | 0 | 0 | 2 |
| 7 | 7 | Resort Hotel | 9 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | FB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0.0 | No Deposit | 303.0 | nan | 0 | Transient | 0 | 1 | 2 |
| 8 | 11 | Resort Hotel | 35 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | HB | PRT | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0.0 | No Deposit | 240.0 | nan | 0 | Transient | 0 | 0 | 4 |
| 9 | 12 | Resort Hotel | 68 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | USA | Online TA | TA/TO | 0 | 0 | 0 | D | E | 0.0 | No Deposit | 240.0 | nan | 0 | Transient | 0 | 3 | 4 |
Last rows
| df_index | hotel | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | required_car_parking_spaces | total_of_special_requests | stays_total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75156 | 119380 | City Hotel | 44 | 2017 | 8 | 35 | 31 | 2 | 0.0 | 0 | SC | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 9.0 | nan | 0 | Transient | 0 | 1 | 4 |
| 75157 | 119381 | City Hotel | 188 | 2017 | 8 | 35 | 31 | 2 | 0.0 | 0 | BB | DEU | Direct | Direct | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 14.0 | nan | 0 | Transient | 0 | 0 | 5 |
| 75158 | 119382 | City Hotel | 135 | 2017 | 8 | 35 | 30 | 3 | 0.0 | 0 | BB | JPN | Online TA | TA/TO | 0 | 0 | 0 | G | G | 0.0 | No Deposit | 7.0 | nan | 0 | Transient | 0 | 0 | 6 |
| 75159 | 119383 | City Hotel | 164 | 2017 | 8 | 35 | 31 | 2 | 0.0 | 0 | BB | DEU | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 42.0 | nan | 0 | Transient | 0 | 0 | 6 |
| 75160 | 119384 | City Hotel | 21 | 2017 | 8 | 35 | 30 | 2 | 0.0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 394.0 | nan | 0 | Transient | 0 | 2 | 7 |
| 75161 | 119385 | City Hotel | 23 | 2017 | 8 | 35 | 30 | 2 | 0.0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 394.0 | nan | 0 | Transient | 0 | 0 | 7 |
| 75162 | 119386 | City Hotel | 102 | 2017 | 8 | 35 | 31 | 3 | 0.0 | 0 | BB | FRA | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0.0 | No Deposit | 9.0 | nan | 0 | Transient | 0 | 2 | 7 |
| 75163 | 119387 | City Hotel | 34 | 2017 | 8 | 35 | 31 | 2 | 0.0 | 0 | BB | DEU | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0.0 | No Deposit | 9.0 | nan | 0 | Transient | 0 | 4 | 7 |
| 75164 | 119388 | City Hotel | 109 | 2017 | 8 | 35 | 31 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 89.0 | nan | 0 | Transient | 0 | 0 | 7 |
| 75165 | 119389 | City Hotel | 205 | 2017 | 8 | 35 | 29 | 2 | 0.0 | 0 | HB | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 9.0 | nan | 0 | Transient | 0 | 2 | 9 |